Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TenderTypeCode (PK) | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. Sample Values: CASH - currency CREDIT - credit card DEBIT - debit card CUST_ACCT - customer credit account with retailer EBT - electronic benefits transfer CHEQUE - personal or business cheque STORED_VALUE - gift cert. or gift card COUPON - mfg coupon VOUCHER - retailer issued debit (e.g. coinstar voucher) SEND_CHECK - paid out/refund via acct pay. TRADEIN - trade in kind/trade in debit OTHER - other debit offset tender type | TY_TND | Code | varchar(20) | |
TenderClassCode (FK) | A code to denote a group of tenders with common characteristics, eg charge cards, certificates, etc. Sample values include: CASH - currency CREDIT - credit card DEBIT - debit card EBT - electronic benefits transfer CHEQUE - personal or business cheque STORED_VALUE - gift cert. or gift card COUPON - mfg coupon VOUCHER - retailer issued debit (e.g. coinstar voucher) OTHER - other debit offset tender type | LU_CLS_TND | Code | varchar(20) | TenderClass(CO_CLS_TND) |
FinancialLedgerAccountID (FK) | The reference for the FinancialLedgeraAccount | ID_ACNT_LDG | Identity | integer | FinancialLedgerAccount(CO_LE_ACNT_FN) |
Description | Description of the tender type. | DE_TND | DescriptionShort | varchar(255) | |
SerialIdentificationNumberRequiredFlag | A flag to signify that the serial number of the tender type has to be captured as part of the tender process. Examples include gift certificates, checks, travelers checks, etc. | FL_NMB_SRZ_IDN_RQ | Flag | integer | |
AuthorizationRequiredFlag | A flag that signifies whether authorization is required before a specific tender can be accepted. | FL_AZN_RQ | Flag | integer | |
AuthorizationMethodCode | A code to signify the method of authorization. For example, checks may be authorized by either a third party or by validation against the customer's driving license. | LU_MTH_AZN | Code2 | char(2) | |
AuthorizationExpirationDateRequiredFlag | Defines a requirement that this type of tender requires an authorization expiration date and that it must be recorded at the time of settlement. | FL_DT_AZN_EP_RQ | Flag | integer | |
AuthorizationMaximumWaitAllowedSecondsCount | Maximum time delay (measured in seconds) allowed to wait for external tender authorization for this TENDER type. | IN_WIT_AZN_MXM_ALW | Quantity | DECIMAL(9,3) | |
CustomerIdentificationRequiredFlag | A flag to signify that customer identification is required, such as driver's license. | FL_IDTN_RQ_CT | Flag | integer | |
PersonalIdentificationNumberRequiredFlag | A flag that requires the customer to enter a personal identification number (PIN) to validate the method of payment. PINs are normally required for debit card payments. | FL_ID_PRSL_RQ | Flag | integer | |
CustomerSignatureRequiredFlag | A flag that requires the customer to sign the tender( check) or resultant voucher (card) in the presence of the operator. | FL_SGNTR_CT_RQ | Flag | integer | |
AccountIdentificationRequiredFlag | A flag to signify that the status of the account has to be checked before this method of tender can be accepted. | FL_ACNT_ID_RQ | Flag | integer | |
OnLineTenderFloorApprovalAmount | The value of an individual tender above which authorization has to be sought before acceptance. This limit is normally referred to as the floor limit and may vary by merchandise and store. | MO_APVL_TNDFLR_ON | Money | decimal(16,5) | |
OnLineTenderCeilingApprovalAmount | The maximum amount of an individual tender type that can be authorized either in-house or by a third party. This especially applies to checks where the check authorization company sets a ceiling by retailer. | MO_APVL_TNDCE_ON | Money | decimal(16,5) | |
OffLineTenderFloorApprovalAmount | The value of an individual tender below which approval is not required. | MO_APVL_TNDFLR_OFF | Money | decimal(16,5) | |
OffLineTenderCeilingApprovalAmount | The maximum value of an individual tender that can be accepted without authorization. | MO_APVL_TNDCE_OFF | Money | decimal(16,5) | |
MinimumAcceptAmount | The minimum value that can be accepted for an individual tender. For example, certain retailers will not accept card payments below $5. | LL_ACPT_TND | Money | decimal(16,5) | |
MaximumAcceptAmount | The maximum amount that can be accepted for a specific tender type. | LU_ACPT_TND | Money | decimal(16,5) | |
OverrideTriggerMaximumAmount | A trigger to override the maximum amount normally accepted for a specific tender type. | UL_OVRD_TRGR | Money | decimal(16,5) | |
LoanPermissibilityFlag | A flag to signify whether a specific transaction can be paid for on credit. | FL_PRMS_TND_LON | Flag | integer | |
ItemRestrictionsApplyFlag | A flag to signify that specific groups of items cannot be purchased using certain tender types. For example, food stamps cannot be used to purchase alcohol or tobacco items. | FL_RST_APLY | Flag | integer | |
LocalCurrencyAvailabilityFlag | A flag to signify that change can be offered to the customer in the currency tendered. | FL_AVLB_LCL_CNY | Flag | integer | |
RealtimeBalanceUpdateFlag | A flag to signify that the customer's account is updated in real-time. | FL_UPDT_RLTM_BLNC | Flag | integer | |
EndorsementRequiredFlag | A flag to signify that an endorsement, normally the customer's signature, is required before a specific tender type can be accepted. | FL_ENDSM_RQ | Flag | integer | |
OpenCashDrawerRequiredFlag | A flag that signifies that the cash drawer opens if a certain specific tender type is offered by the customer. For example, cash. Other forms of tender, such as checks, can be inserted into the till through a slit in the cash drawer door without the cash drawer opening, or alternatively, into a separate security device adjacent to the register. | FL_DRW_OPN_CSH_RQ | Flag | integer | |
ChangeThresholdAmount | The maximum change that can be offered to a customer for a specific tender type. | MO_TH_TND_CHN | Money | decimal(16,5) | |
UnitCountRequiredFlag | A flag to signify that specific tender type units need to be counted and recorded by the operator prior to a pickup. | FL_RQ_TND_UN_CNT | Flag | integer | |
AmountCountRequiredFlag | A flag to signify that a specific tender type amount needs to be counted and recorded by the operator prior to a pickup | FL_RQ_TND_AMT_CNT | Flag | integer | |
AcceptanceForPaymentOnAccountFlag | A flag to signify that a certain tender type can be accepted to credit a customer's account. | FL_POA_TND_ACTPN | Flag | integer | |
MagneticStripeReaderRequiredFlag | A flag to signify that the tender type has to be inserted into the magnetic card reader. For example, credit and debit cards. | FL_MSR_RQ | Flag | integer | |
CheckEncodingFlag | A flag to denote whether a check is encoded with the bank deposit account and the reserve and transit number to facilitate automated handling by the EXTERNAL DEPOSITORY. | FL_CHK_ENC | Flag | integer | |
PayOutPermissibilityFlag | A boolean indicator that tells if this TENDER may be paid out from a till as part of a miscellaneous expense or other properly authorized tender disbursement. If this flag is set to NO, this TENDER may NOT be paid out of a till. | FL_PY_OT_PRMS | Flag | integer | |
PaymentServiceProviderID (FK) | The identifier for an electonic payment service provider. | ID_PYM_SV_PVR | Identity | integer | PaymentServiceProvider(PA_PYM_SV_PVR) |
ISOCurrencyCode (FK) | Currency code designated by ISO to identify national currency | CD_CNY_ISO_4217 | ISO_4217_CurrencyCode_char(3) | char(3) | ISO4217-CurrencyType(LU_CNY_ISO_4217) |